Telegram Group & Telegram Channel
Telegram Group » Hong Kong » SQL для тестировщика » Telegram Webview » Post 172
SQL для тестировщика
Даны следующие таблицы:

Students

| StudentID | Name | Age | Gender |
|-----------|-----------|-----|--------|
| 1 | John | 20 | Male |
| 2 | Jane | 22 | Female |
| 3 | Mark | 21 | Male |
| 4 | Sarah | 23 | Female |
| 5 | Michael | 20 | Male |

Courses

| CourseID | CourseName | Credits |
|----------|------------------|---------|
| 101 | Mathematics | 3 |
| 102 | Physics | 4 |
| 103 | Chemistry | 3 |
| 104 | English | 2 |
| 105 | History | 3 |

Enrollments
| EnrollmentID | StudentID | CourseID |
|--------------|-----------|----------|
| 1            | 1         | 101      |
| 2            | 2         | 101      |
| 3            | 3         | 102      |
| 4            | 4         | 101      |
| 5            | 1         | 103      |
| 6            | 2         | 105      |
| 7            | 3         | 104      |
| 8            | 4         | 102      |
| 9            | 5         | 101      |
| 10           | 5         | 103      |

Какой из следующих SQL запросов отберет всех студентов женского пола, записанных на курс "Mathemetics"?

A) SELECT Name FROM Students WHERE Gender = 'Female' AND StudentID IN (SELECT StudentID FROM Enrollments WHERE CourseName = 'Mathematics')

B) SELECT Name FROM Students JOIN Enrollments ON Students.StudentID = Enrollments.StudentID WHERE Gender = 'Female' AND CourseName = 'Mathematics'

C) SELECT Name FROM Students WHERE Gender = 'Female' AND StudentID = (SELECT StudentID FROM Enrollments WHERE CourseName = 'Mathematics')

D) SELECT Name FROM Students JOIN Enrollments ON Students.StudentID = Enrollments.StudentID WHERE Gender = 'Female' AND CourseID = 101
www.tg-me.com/hk/SQL для тестировщика/com.sql_for_qa/172
1.7K views



tg-me.com/sql_for_qa/172
Create:
Last Update:

Даны следующие таблицы:

Students

| StudentID | Name | Age | Gender |
|-----------|-----------|-----|--------|
| 1 | John | 20 | Male |
| 2 | Jane | 22 | Female |
| 3 | Mark | 21 | Male |
| 4 | Sarah | 23 | Female |
| 5 | Michael | 20 | Male |

Courses

| CourseID | CourseName | Credits |
|----------|------------------|---------|
| 101 | Mathematics | 3 |
| 102 | Physics | 4 |
| 103 | Chemistry | 3 |
| 104 | English | 2 |
| 105 | History | 3 |

Enrollments

| EnrollmentID | StudentID | CourseID |
|--------------|-----------|----------|
| 1            | 1         | 101      |
| 2            | 2         | 101      |
| 3            | 3         | 102      |
| 4            | 4         | 101      |
| 5            | 1         | 103      |
| 6            | 2         | 105      |
| 7            | 3         | 104      |
| 8            | 4         | 102      |
| 9            | 5         | 101      |
| 10           | 5         | 103      |

Какой из следующих SQL запросов отберет всех студентов женского пола, записанных на курс "Mathemetics"?

A) SELECT Name FROM Students WHERE Gender = 'Female' AND StudentID IN (SELECT StudentID FROM Enrollments WHERE CourseName = 'Mathematics')

B) SELECT Name FROM Students JOIN Enrollments ON Students.StudentID = Enrollments.StudentID WHERE Gender = 'Female' AND CourseName = 'Mathematics'

C) SELECT Name FROM Students WHERE Gender = 'Female' AND StudentID = (SELECT StudentID FROM Enrollments WHERE CourseName = 'Mathematics')

D) SELECT Name FROM Students JOIN Enrollments ON Students.StudentID = Enrollments.StudentID WHERE Gender = 'Female' AND CourseID = 101

BY SQL для тестировщика


Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/172

View MORE
Open in Telegram


SQL для тестировщика Telegram | DID YOU KNOW?

Date: |

How to Use Bitcoin?

n the U.S. people generally use Bitcoin as an alternative investment, helping diversify a portfolio apart from stocks and bonds. You can also use Bitcoin to make purchases, but the number of vendors that accept the cryptocurrency is still limited. Big companies that accept Bitcoin include Overstock, AT&T and Twitch. You may also find that some small local retailers or certain websites take Bitcoin, but you’ll have to do some digging. That said, PayPal has announced that it will enable cryptocurrency as a funding source for purchases this year, financing purchases by automatically converting crypto holdings to fiat currency for users. “They have 346 million users and they’re connected to 26 million merchants,” says Spencer Montgomery, founder of Uinta Crypto Consulting. “It’s huge.”

What is Telegram?

Telegram’s stand out feature is its encryption scheme that keeps messages and media secure in transit. The scheme is known as MTProto and is based on 256-bit AES encryption, RSA encryption, and Diffie-Hellman key exchange. The result of this complicated and technical-sounding jargon? A messaging service that claims to keep your data safe.Why do we say claims? When dealing with security, you always want to leave room for scrutiny, and a few cryptography experts have criticized the system. Overall, any level of encryption is better than none, but a level of discretion should always be observed with any online connected system, even Telegram.

SQL для тестировщика from hk


Даны следующие таблицы:Students| StudentID | Name | Age | Gender ||-----------|-----------|-----|--------|| 1 | John | 20 | Male || 2 | Jane | 22 | Female || 3 | Mark | 21 | Male || 4 | Sarah | 23 | Female || 5 | Michael | 20 | Male |Courses| CourseID | CourseName | Credits ||----------|------------------|---------|| 101 | Mathematics | 3 || 102 | Physics | 4 || 103 | Chemistry | 3 || 104 | English | 2 || 105 | History | 3 |Enrollments| EnrollmentID | StudentID | CourseID ||--------------|-----------|----------|| 1 | 1 | 101 || 2 | 2 | 101 || 3 | 3 | 102 || 4 | 4 | 101 || 5 | 1 | 103 || 6 | 2 | 105 || 7 | 3 | 104 || 8 | 4 | 102 || 9 | 5 | 101 || 10 | 5 | 103 |Какой из следующих SQL запросов отберет всех студентов женского пола

 SQL для тестировщика TG
Webview: 172
SQL для тестировщика.Telegram Webview
SQL для тестировщика Telegram TG Channel
Telegram Updated:
Telegram SQL для тестировщика
FROM USA